<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" pageEncoding="UTF-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jstl/fmt_rt" %>

<html>
<head>
    <title>登录页</title>
    <%--echart线图、柱状图、饼图等各种图型库 cdn--%>
    <script type="text/javascript" src="https://cdn.jsdelivr.net/npm/echarts/dist/echarts.min.js"></script>
    <%--jquery cdn--%>
    <script type="text/javascript" src="https://cdn.bootcdn.net/ajax/libs/jquery/3.6.1/jquery.js"></script>
</head>
<body>
小组<select name="group">
    <option value="1">1组</option>
    <option value="2">2组</option>
    <option value="3">3组</option>
    <option value="5">5组</option>
    <option value="7">7组</option>

</select>
<button onclick="zxt()">点击展示折线图</button>
<button onclick="zzt()">点击展示柱状图</button>
<button onclick="bing()">点击展示饼状图</button>
<button onclick="excel()">点击导出Excel</button>
<div id="main" style="width: 600px;height: 600px"></div>

</body>

<script>

    function excel() {
        let group = $('[name=group]').val();
        window.location.href = '/excel.do?group=' + group
    }



    function bing() {
        $.ajax({
            url: 'bing.do',
            success: function (data) {
                console.log(data)

                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    title: {
                        text: 'Referer of a Website',
                        subtext: 'Fake Data',
                        left: 'center'
                    },
                    tooltip: {
                        trigger: 'item'
                    },
                    legend: {
                        orient: 'vertical',
                        left: 'left'
                    },
                    series: [
                        {
                            name: 'Access From',
                            type: 'pie',
                            radius: '50%',
                            data: data,
                            emphasis: {
                                itemStyle: {
                                    shadowBlur: 10,
                                    shadowOffsetX: 0,
                                    shadowColor: 'rgba(0, 0, 0, 0.5)'
                                }
                            }
                        }
                    ]
                };

                option && myChart.setOption(option);

            }
        })
    }


    function zzt() {
        $.ajax({
            url: '/stuCount.do',
            success: function (data) {
                console.log(data)
                // 把x轴 y轴拆解出来 得到两个数组
                var xArray = [];
                var yArray = [];

                for (let i = 0; i < data.length; i++) {
                    let xdata = data[i].xdata;
                    let ydata = data[i].ydata;
                    xArray.push(xdata)
                    yArray.push(ydata)
                }
                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: xArray
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: yArray,
                            type: 'bar',
                            showBackground: true,
                            backgroundStyle: {
                                color: 'rgba(180, 180, 180, 0.2)'
                            }
                        }
                    ]
                };

                option && myChart.setOption(option);


            }
        })


    }


    function zxt() {
        // 获取下拉框的值
        let group = $('[name=group]').val();

        $.ajax({
            url: '/stuCountByGroup.do?group=' + group,
            success: function (data) {
                console.log(data)
                // 把x轴 y轴拆解出来 得到两个数组
                var xArray = [];
                var yArray = [];

                for (let i = 0; i < data.length; i++) {
                    let xdata = data[i].xdata;
                    let ydata = data[i].ydata;
                    xArray.push(xdata)
                    yArray.push(ydata)
                }

                var chartDom = document.getElementById('main');
                var myChart = echarts.init(chartDom);
                var option;

                option = {
                    xAxis: {
                        type: 'category',
                        data: xArray
                    },
                    yAxis: {
                        type: 'value'
                    },
                    series: [
                        {
                            data: yArray,
                            type: 'line'
                        }
                    ]
                };
                option && myChart.setOption(option);

            }
        })


    }

</script>
</html>